| PlStudentIndustry |
| Logical Entity Name | PlStudentIndustry |
| Default Table Name | PlStudentIndustry |
| Physical Only | NO |
| Definition | |
| Note |
| PlStudentIndustry Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
PlStudentIndustryID |
int | NO | ||
PlStudentID |
int | NO | ||
PlIndustryID |
int | NO | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO |
| PlStudentIndustry Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PlStudentIndustry_PlStudentIndustryID_U_C_IDX | PrimaryKey | PlStudentIndustryID |
| PlStudentIndustry Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| PlIndustry | Non-Identifying | One To Zero or More | FK_PlStudentIndustry.PlIndustryID_PlIndustry.PlIndustryID | PlIndustryID | NO | YES | ||
| PlStudent | Non-Identifying | One To Zero or More | FK_PlStudentIndustry.PlStudentID_PlStudent.PlStudentID | PlStudentID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_PlStudentIndustry.UserID_SyStaff.SyStaffID | UserID | NO | YES | ||
| PlStudent | Non-Identifying | One To Zero or More | FK_PlStudentIndustry_PlStudentID_PlStudent_PlStudentID | PlStudentID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| PlStudentIndustry Check Constraints |
| Check Constraint Name | CheckConstraint |